UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd27pPKA0HhH1lAQrg1cTVNEgVCY5hDSZ1o1cI0RlOfk='
WHERE
key_id = 'f56a98110e00a001dfba98043656841c7df35c541466b602b24e98ce478bf2ba'
AND (
token = 'd27pPKA0HhH1lAQrg1cTVNEgVCY5hDSZ1o1cI0RlOfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)