UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnDrhE1stG60kB/IS1a146fkI00xFRR4lw511HdwDwo='
WHERE
key_id = 'ec927f532c810bab91afd36cb3028e419d9d193965dea8062a43fc55cd8e6fdd'
AND (
token = 'TnDrhE1stG60kB/IS1a146fkI00xFRR4lw511HdwDwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)