UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SKpnTKprQvrhSKgkLrh1NiiglbzUcDVnPoVb0cz9xa0='
WHERE
key_id = '4507d0c9145615e400656fd00ef134859f52d61523777d996c7fca27a9cc4374'
AND (
token = 'SKpnTKprQvrhSKgkLrh1NiiglbzUcDVnPoVb0cz9xa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)