UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pU2dCg1GVm5c6+r3DFRxMxzQj2vCXKtN94VfOve/Qs='
WHERE
key_id = '4d80f7c2b047affa5067e24314a9f89dd1421db83fb2c7e57320116da908ae71'
AND (
token = '3pU2dCg1GVm5c6+r3DFRxMxzQj2vCXKtN94VfOve/Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)