UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxGuSXFvRuOseu6kZrmSPn0X5cLS0tCN4Eob0rV8Krs='
WHERE
key_id = '147cfa19c53d2a8d370c0e391d91c588dd22d56b55316c9b9e34fa4fecb7defc'
AND (
token = 'ZxGuSXFvRuOseu6kZrmSPn0X5cLS0tCN4Eob0rV8Krs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)