UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AstudRq0PrkfB24l4pzvqsKq41Lr6n4NSsz4f9Rc2X8='
WHERE
key_id = '20d7b66b2bdf50af88ab3252cad5a2674ec769b18cef54dacb1fb5ac92cfdafb'
AND (
token = 'AstudRq0PrkfB24l4pzvqsKq41Lr6n4NSsz4f9Rc2X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)