UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7NIfc4HMV875w/VWMqwu1Tna0RTWH6q65BZCUlVvR4='
WHERE
key_id = 'f411bedb6a16fc44556a83968dca2725c9294a94666624bcf08d070074d7f678'
AND (
token = 'k7NIfc4HMV875w/VWMqwu1Tna0RTWH6q65BZCUlVvR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)