UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0iW99ag+qEPuvhHvy8EhbLza2lQTPZgnCGwv42vq41U='
WHERE
key_id = 'ebdc2140d7833cabe8cbfc9ff5b6c4aeb254526d34660ce335f8bc71c72425c3'
AND (
token = '0iW99ag+qEPuvhHvy8EhbLza2lQTPZgnCGwv42vq41U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)