UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3wKdIFx6LpMpM4U28ICnjsTqz0PrszkIm1ICN9Mwra0='
WHERE
key_id = 'aa53d2adf3f6bfb1361ddc1f45aaff2f8d66478716760a8a311f126217a7049d'
AND (
token = '3wKdIFx6LpMpM4U28ICnjsTqz0PrszkIm1ICN9Mwra0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)