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