UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Idz29tHpa3wch84AP8hfP31DJtyqFFPndmFize1+Pw='
WHERE
key_id = 'bb4297710408c120b593ba46588fb56033affe60bc8c83217608d1382a6beffc'
AND (
token = '7Idz29tHpa3wch84AP8hfP31DJtyqFFPndmFize1+Pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)