UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V3jkwrC/1IOZn4dPXcmybisyCMLO3+yKaWpdu6L1N/4='
WHERE
key_id = '38e9d9650134c166dd730994de6097b752b70718edee0f0e3ae6cf4e90214905'
AND (
token = 'V3jkwrC/1IOZn4dPXcmybisyCMLO3+yKaWpdu6L1N/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)