UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpOhS6kmgaYsBVYynAXC1o0avFDXsfVtaX3s6demUWw='
WHERE
key_id = '83bc12b8f24c6810aef9acefe8c3bf008f870adc9a683198ceaa8ebbe81d6cdb'
AND (
token = 'HpOhS6kmgaYsBVYynAXC1o0avFDXsfVtaX3s6demUWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)