UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N0DyigIPsBWMmBM3pc5OI6pMo9Fhf9yyzhqPWEJWXqI='
WHERE
key_id = '073c367a7ef595d26a444862469239cde53e92df0b4a04f8a58235708862f544'
AND (
token = 'N0DyigIPsBWMmBM3pc5OI6pMo9Fhf9yyzhqPWEJWXqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)