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