UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6TDz+3UwbDXPE7ARHPhuV9GohS3QLDZFU5+jB38kk8='
WHERE
key_id = '19c1c367ff913fad4933f125fc16a81e072a2801fb08a73c20c177f4eaf10942'
AND (
token = 'D6TDz+3UwbDXPE7ARHPhuV9GohS3QLDZFU5+jB38kk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)