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