UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HEcIA1TwThLEhcxQykx3WHUOVAzpv6rX2nSG4izLxtI='
WHERE
key_id = 'd13264d73efb7def226798a5d855041c21612b45ad0748d73a9b2a4c32efe57b'
AND (
token = 'HEcIA1TwThLEhcxQykx3WHUOVAzpv6rX2nSG4izLxtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)