UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCh5G5Bj6wjyP0QZHbzmHWDljVrPa6gSBRLCQXUbqM4='
WHERE
key_id = '2b1429bd9c2778b922b24a6cad7e8605a87fb803859fe695ee5c642e9a7c9c3e'
AND (
token = 'gCh5G5Bj6wjyP0QZHbzmHWDljVrPa6gSBRLCQXUbqM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)