UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ISImnhPA+jADY6PoeJ5Phz0zUG1y1SKuVArbUy09TL8='
WHERE
key_id = '1475a6d034647a068dedfbde447d89a2879a1bd67ceb41dade0b3eaf9f88d8a9'
AND (
token = 'ISImnhPA+jADY6PoeJ5Phz0zUG1y1SKuVArbUy09TL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)