UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imQXgahxDA4LSLZC6PXvOM/QtDmUvp+/mLCD+A9wN5w='
WHERE
key_id = 'ab56dff72baaca1e5897832e786e23a7b94218a8e3c2583316ed8cbb2fe4fc1d'
AND (
token = 'imQXgahxDA4LSLZC6PXvOM/QtDmUvp+/mLCD+A9wN5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)