UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9HrD/jiEqrLff6cbnaPFHwEgv5ihwGUH96YU8nkPv0='
WHERE
key_id = '0785100dc1b056bd10b824df2cd854b6a4372df8bb08a675681cc3e71a04f04f'
AND (
token = 'J9HrD/jiEqrLff6cbnaPFHwEgv5ihwGUH96YU8nkPv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)