UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GjJju7xAiP4r0t7RP0kODleGJIz8cUkleU6pCcSkrk='
WHERE
key_id = 'd172a46c9404104831990fc7276c19881d10d2df0bd6358c7a6eec0780a9e0c6'
AND (
token = '3GjJju7xAiP4r0t7RP0kODleGJIz8cUkleU6pCcSkrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)