UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Tm3ZbIhztU5qPFPu22FTUdLXXuxg9ApAjSdEUs5etk='
WHERE
key_id = '824bc9a5705106145d79e7c725d1fb6545fac4698776ddf34713b488aed2b310'
AND (
token = '8Tm3ZbIhztU5qPFPu22FTUdLXXuxg9ApAjSdEUs5etk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)