UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFbTRfcc25BANwaUpn8eLVu4iOO/GD/SdsT+iF7cCvA='
WHERE
key_id = '77a0ad0438ef67696159426491dd15bf3057bd0a4475b71e62b2b69807f15060'
AND (
token = 'zFbTRfcc25BANwaUpn8eLVu4iOO/GD/SdsT+iF7cCvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)