UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NP1xAe3lUNVDm/04cjic29yrZdQsohgDZTsDu2S/mcM='
WHERE
key_id = '8d59260ec02d1d33b792eb5437a0fbbd8a761942cbcf73095ab3a4a7eaa9fabf'
AND (
token = 'NP1xAe3lUNVDm/04cjic29yrZdQsohgDZTsDu2S/mcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)