UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6jdfP6glpqTUqnvJ+oJLIa9qYs7w6IFjAzFVN8YQEc='
WHERE
key_id = '06d721c54aac98502b4190deea5c45592bfd4ba9a9e3fc89e3d47a4bae5f3339'
AND (
token = 'z6jdfP6glpqTUqnvJ+oJLIa9qYs7w6IFjAzFVN8YQEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)