UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PPs50w9aGq3IpDPj3/Mrh6S2hUnaHPfp/WinX8XqsuY='
WHERE
key_id = 'a325f4baaf7067b34864f5c80b4c3420a8ddaeda48fe77f2e2a88d7106bcf28e'
AND (
token = 'PPs50w9aGq3IpDPj3/Mrh6S2hUnaHPfp/WinX8XqsuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)