UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MnFsJHIUc5BrwX6G7kbkD1mEk/+m4AiUQRX1h9oj6/8='
WHERE
key_id = 'fd49fb1e284619b30891e05b5f638662d6e47751706554d03afa15c4cd823201'
AND (
token = 'MnFsJHIUc5BrwX6G7kbkD1mEk/+m4AiUQRX1h9oj6/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)