UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ1AEalj09i7FLv9O+8zZ86q8FQRc+5ABs4kgPI8uOU='
WHERE
key_id = 'e165dd0d63172794f84b2b4bca75ea9a622b2a6ee931485e3227e2dfb83c837e'
AND (
token = 'gJ1AEalj09i7FLv9O+8zZ86q8FQRc+5ABs4kgPI8uOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)