UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uGYaPPTmn5pnrJqO4I5hu5RnHOeBqMee55SfkeWRdGU='
WHERE
key_id = '6bc3e41febd108ffecb44847fa2b6f2a1201c877c23033403dd7d35f78716320'
AND (
token = 'uGYaPPTmn5pnrJqO4I5hu5RnHOeBqMee55SfkeWRdGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)