UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/E4toc6QEr3XVu2SbVWPwNQGnDuUEv4cQuRDr1UK6xw='
WHERE
key_id = 'a3161e458b67df7013187ff625346e54e4f18abe7af1c0d1f069ede7f632ad3a'
AND (
token = '/E4toc6QEr3XVu2SbVWPwNQGnDuUEv4cQuRDr1UK6xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)