UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5mddimvJOnH6IcnadIfdNvIcH3ogjBxDkx9LZ/Snj7g='
WHERE
key_id = '09a9c6bea389858417ae3c334acdbcbe461c9284d49d9af20342b7fe70a79309'
AND (
token = '5mddimvJOnH6IcnadIfdNvIcH3ogjBxDkx9LZ/Snj7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)