UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BTSpjiCLVnx4D4fSqCdjO91qL+F7LEHo+bq1N5E98M='
WHERE
key_id = 'db27eac93a6b730345f2f88dcd4637c7ac7a31e43b4195505d381ab70175719a'
AND (
token = '1BTSpjiCLVnx4D4fSqCdjO91qL+F7LEHo+bq1N5E98M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)