UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vtnz1hL/UtGS6PAQ2aN1WWN2Jzw4MWl7jQpdIja9R34='
WHERE
key_id = '4d7afd87afca985e062cca7c579952980420404a6b45e8c3f731a46aae7dc4a5'
AND (
token = 'Vtnz1hL/UtGS6PAQ2aN1WWN2Jzw4MWl7jQpdIja9R34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)