UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BoIaZfSupq8PN5gZmEOGGXVLeMrWunxuJISvYG66SoQ='
WHERE
key_id = 'dc51c50b62f3b569ecb5e8991d4df974b9cd0096ec6e4c3fed39828a88a683a1'
AND (
token = 'BoIaZfSupq8PN5gZmEOGGXVLeMrWunxuJISvYG66SoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)