UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JWthmb8vPG1rTva9zTiR11UtBfPB5s5mrABRVLHqssI='
WHERE
key_id = 'c213db9aaccc8bb92e5c741bc9f41eee2a2d0a3557ae0f7b468770e43ce19bc8'
AND (
token = 'JWthmb8vPG1rTva9zTiR11UtBfPB5s5mrABRVLHqssI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)