UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKL3h6gCzwE6J0MJjB1wAJp7xHfg0SxPsv/vs/1cTrE='
WHERE
key_id = 'cee7552a18263461454defa1356ae7ececcc552d1da9a035d9ca30ac859eb067'
AND (
token = 'zKL3h6gCzwE6J0MJjB1wAJp7xHfg0SxPsv/vs/1cTrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)