UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4r9l3emzax8UoI5zLeXGZ3lUFoCd/vv/Me6YGeSmmTg='
WHERE
key_id = '0ef7742292fa94c0c350ffb34f9d487d341e687f72c49d4de99ed0f70a522d30'
AND (
token = '4r9l3emzax8UoI5zLeXGZ3lUFoCd/vv/Me6YGeSmmTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)