UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WioXU376AbhruF3DIKPXVjtN4bfahH0r0k61vSdE+9s='
WHERE
key_id = 'ecea2eefe67dd1113cf4a40f336ca9e0c10a4766ed899b0a47cf912283df6b9d'
AND (
token = 'WioXU376AbhruF3DIKPXVjtN4bfahH0r0k61vSdE+9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)