UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lzZZL7lR3BBXmThe5Aa67Jj/iUmFJEvk49o18L1Yyik='
WHERE
key_id = 'dbcf648f025b73b005526426a587688beac5fe67ce2085e095c28f1fc90c8b2e'
AND (
token = 'lzZZL7lR3BBXmThe5Aa67Jj/iUmFJEvk49o18L1Yyik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)