UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BifwbLn1zZZC9IlKp7X0BWirlfzzmjTk0FYlu5HdgCI='
WHERE
key_id = '13b030e41b104e5510ff711de6d0325502f3b19af172d1d5bc668608b974f6d3'
AND (
token = 'BifwbLn1zZZC9IlKp7X0BWirlfzzmjTk0FYlu5HdgCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)