UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HJ5vtIicmIojqmS09n4oUI2rUhuTP75G6MK9iOjby0='
WHERE
key_id = 'a1f4b50356616cf37fec91447723f78a49b7f5c265ca3e5ad9a385a6322b98db'
AND (
token = '4HJ5vtIicmIojqmS09n4oUI2rUhuTP75G6MK9iOjby0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)