UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4YpGruYMeGKSdE9I57OxmSYj+WGMQNG4v+L+IQzz0Y='
WHERE
key_id = 'a2c1cf62640b22b9523fdc7789b60f76172a5afc6c1fdee05d763ac687141fc6'
AND (
token = 'q4YpGruYMeGKSdE9I57OxmSYj+WGMQNG4v+L+IQzz0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)