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