UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jjICUdUV4fQl9eFoFtXL/kcBbCtCEkikshQcQXGf2x4='
WHERE
key_id = '9420dce107a289c3fb4f17c8b3bd26ebce918ea894308bb6dfb747220cdd348d'
AND (
token = 'jjICUdUV4fQl9eFoFtXL/kcBbCtCEkikshQcQXGf2x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)